PowerTools SPREAD for Windows Forms 10.0J
GetValidConditionalFormat(Int32,Int32,IPrePaintConditionalFormattingRule[],IPrePaintTextConditionalFormattingRule[]) メソッド


行インデックス
列インデックス
描画前条件付き書式ルール
テキスト描画前条件付き書式ルール
有効な条件付き書式を取得します。
構文
'Declaration
 
Public Sub GetValidConditionalFormat( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByRef prePaintCFRules As IPrePaintConditionalFormattingRule(), _
   ByRef prePaintTextCFRules As IPrePaintTextConditionalFormattingRule() _
) 
'使用法
 
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim prePaintCFRules As IPrePaintConditionalFormattingRule()
Dim prePaintTextCFRules As IPrePaintTextConditionalFormattingRule()
 
instance.GetValidConditionalFormat(row, column, prePaintCFRules, prePaintTextCFRules)

パラメータ

row
行インデックス
column
列インデックス
prePaintCFRules
描画前条件付き書式ルール
prePaintTextCFRules
テキスト描画前条件付き書式ルール
次のサンプルコードは、GetValidConditionalFormatメソッドを使用します。
private void Form1_Load(object sender, EventArgs e)
        {
            fpSpread1.Sheets[0].Cells[0, 0].Value = 3;
            fpSpread1.Sheets[0].Cells[1, 0].Value = 2;
            fpSpread1.Sheets[0].Cells[1, 1].Value = 10;
            fpSpread1.Sheets[0].Cells[0, 2].Value = 1;            
        }

        private void button1_Click(object sender, EventArgs e)
        {
FarPoint.Win.Spread.UnaryComparisonConditionalFormattingRule unary = new FarPoint.Win.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo, 3, false);
unary.Operator = FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo;
//unary.Value = 3;
unary.BackColor = Color.Red;
unary.FontStyle = new FarPoint.Win.Spread.SpreadFontStyle(RegularBoldItalicFontStyle.Bold);

fpSpread1.ActiveSheet.SetConditionalFormatting(1, 1, unary);
fpSpread1.ActiveSheet.SetConditionalFormatting(0, 0, unary);

FarPoint.Win.Spread.IPrePaintConditionalFormattingRule[] prePaintRule;
FarPoint.Win.Spread.IPrePaintTextConditionalFormattingRule[] prePaintTextRule;
fpSpread1.ActiveSheet.GetValidConditionalFormat(0, 0, out prePaintRule, out prePaintTextRule);

FarPoint.Win.Spread.PrePaintResult pp = prePaintRule[0].Execute(0, 0, fpSpread1.ActiveSheet.Cells[0, 0].Value);
FarPoint.Win.Spread.StyleInfo source = new FarPoint.Win.Spread.StyleInfo();
fpSpread1.ActiveSheet.Cells[1, 1].Value = 3;
FarPoint.Win.Spread.PrePaintResult pp1 = prePaintRule[0].Execute(1, 1, fpSpread1.ActiveSheet.Cells[1, 1].Value);        
        }
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        FpSpread1.Sheets(0).Cells(0, 0).Value = 3
        FpSpread1.Sheets(0).Cells(1, 0).Value = 2
        FpSpread1.Sheets(0).Cells(1, 1).Value = 10
        FpSpread1.Sheets(0).Cells(0, 2).Value = 1
    End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'Unary comparison CF
Dim unary As New FarPoint.Win.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo, 3, False)
unary.[Operator] = FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo
'unary.Value = 3;
unary.BackColor = Color.Red
unary.FontStyle = New FarPoint.Win.Spread.SpreadFontStyle(RegularBoldItalicFontStyle.Bold)

FpSpread1.ActiveSheet.SetConditionalFormatting(1, 1, unary)
FpSpread1.ActiveSheet.SetConditionalFormatting(0, 0, unary)

Dim prePaintRule As FarPoint.Win.Spread.IPrePaintConditionalFormattingRule()
Dim prePaintTextRule As FarPoint.Win.Spread.IPrePaintTextConditionalFormattingRule()
FpSpread1.ActiveSheet.GetValidConditionalFormat(0, 0, prePaintRule, prePaintTextRule)

Dim pp As FarPoint.Win.Spread.PrePaintResult = prePaintRule(0).Execute(0, 0, FpSpread1.ActiveSheet.Cells(0, 0).Value)
Dim source As New FarPoint.Win.Spread.StyleInfo()
FpSpread1.ActiveSheet.Cells(1, 1).Value = 3
Dim pp1 As FarPoint.Win.Spread.PrePaintResult = prePaintRule(0).Execute(1, 1, FpSpread1.ActiveSheet.Cells(1, 1).Value)
    End Sub
参照

SheetView クラス
SheetView メンバ

 

 


© 2004-2017, GrapeCity inc. All rights reserved.